Limitations

When defining a task with Microsoft Azure Event Hubs as the target endpoint, the following limitations apply:

• The Microsoft Azure Event Hubs target endpoint does not support unlimited LOB size. Therefore, when replicating from source tables with LOB columns, do not select the Allow unlimited LOB size option.

  For more information on defining LOB settings, see Target metadata.

• Batch optimized apply mode is not supported. If this mode is set, the task will automatically switch to Transactional apply mode and issue an appropriate warning.

  For more information on these modes, see Change Processing Tuning.

• Store Changes replication mode is not supported.

  For more information on Store Changes mode, see Adding tasks.

• The Ignore ALTER Apply Changes setting is not supported for changes to source data types and table renaming.

• Column names must begin with [A-Za-z_] (letters or an underscore) followed by [A-Za-z0-9_] (letters, digits, or an underscore). For example, _Test_ is a valid column name whereas &Test is not.

  If a source column name does not adhere to this rule, then a transformation should be used to rename the column.

• The Drop and Create table Target Table Preparation option is not supported
• The Truncate before loading Target Table Preparation option is not supported
• The DDL History and Change Data Partitioning Control tables are not supported
• DDL Changes: Dropping or renaming a table is not supported